UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bn/1+vsvWN634tdYgUWVl3wof3OjN38eaWC+XnToeZ8='
WHERE
key_id = '4b59b07fe2beaf9900b0a54a5ab3d9a9afc422d37900c724165c610fdbc1758d'
AND (
token = 'Bn/1+vsvWN634tdYgUWVl3wof3OjN38eaWC+XnToeZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)