UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nTWTZs3DZfaj8jQvhNP1/txtQhD0UkmKdcvJDZb9ee8='
WHERE
key_id = '4f90d16b9ae152f88b0cc05a26777a51e63d371ac16009e4e9d92785085c9a35'
AND (
token = 'nTWTZs3DZfaj8jQvhNP1/txtQhD0UkmKdcvJDZb9ee8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)