UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zp0vvScp9O8xd8/+EovTw6GeS5ncSNVeXGLleo3rTVw='
WHERE
key_id = 'd1f5864b0c1a20ac8dc43b807b9aba8b8cbc51a3a8153b6a61258db1a102aa6c'
AND (
token = 'Zp0vvScp9O8xd8/+EovTw6GeS5ncSNVeXGLleo3rTVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)