UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSYiXSRsqmnCwM0YENOU0S/BD03XHRPN8nTDeFmUsT0='
WHERE
key_id = 'd3d56e09eda18f30bdaa3ac90791614e773ba9b129c6f928b585a302da6308dd'
AND (
token = 'zSYiXSRsqmnCwM0YENOU0S/BD03XHRPN8nTDeFmUsT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)