UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bVsCoIX9kP6yeTZ2KGGOlV9b5nYy6snI1A3t4OQG3q4='
WHERE
key_id = '48fba2284e8db40784a794119fc174419d54f6c1c8203ad208d05f3a43970186'
AND (
token = 'bVsCoIX9kP6yeTZ2KGGOlV9b5nYy6snI1A3t4OQG3q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)