UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8X/LQZ+iC1KZmo7XMFtA6tra0kGZJ3F9VYpIy4L1mAs='
WHERE
key_id = '24b32efa2c2e4a2befadfe7179deafadba2e83be45c5f2f3fd3d091c7c166453'
AND (
token = '8X/LQZ+iC1KZmo7XMFtA6tra0kGZJ3F9VYpIy4L1mAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)