UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTqReKuFHctzIyoe1drcwq2vP16mGSzKqr5a7fWy5n4='
WHERE
key_id = 'bcd51d890460e0f90ffcb159cd2e4195c0b01ff7a3ab37b0417d2d7e4a3a8cb3'
AND (
token = 'DTqReKuFHctzIyoe1drcwq2vP16mGSzKqr5a7fWy5n4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)