UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zVzO8ilJijzxz5SXFoaFs5R4lX8J+cS8MMwSLy99dM='
WHERE
key_id = 'bd5138fe8a9df3862dbbc73ac334b05fc440a914855d1a6dde4c36bcd04a86ee'
AND (
token = '6zVzO8ilJijzxz5SXFoaFs5R4lX8J+cS8MMwSLy99dM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)