UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oSYgcFzddct7E5Nv9tGY/KzCWv1tiEeDbcEVPLdVdKE='
WHERE
key_id = '7a739988fddd8f0144c23cb1d26561db652ead046bd4ab1dead87d9aa0bb9a01'
AND (
token = 'oSYgcFzddct7E5Nv9tGY/KzCWv1tiEeDbcEVPLdVdKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)