UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5/L6brTIcWJzkIGfENonrh/gCew1dv0a2kq13NV1C3A='
WHERE
key_id = '9d77d59834d74a919e4e9eff06ca353638dd7727d9fd6125bed414374a106f62'
AND (
token = '5/L6brTIcWJzkIGfENonrh/gCew1dv0a2kq13NV1C3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)