UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gK6y1Pr/zaW3adR8+BdmEWO13XQoGWOtjrd/EJsZJpI='
WHERE
key_id = '44b0f80583c1224d1d9688247ead3103cca346278d194c8b8dd775e5daae47e5'
AND (
token = 'gK6y1Pr/zaW3adR8+BdmEWO13XQoGWOtjrd/EJsZJpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)