UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nBXPH7HukNdpDXMHapZTpa4iIDX2pbtfbHH46D+2oHM='
WHERE
key_id = 'ccbb3b9e127f9a945ef58f3ddc36809110dd2fac3c1a0166bf94c151c1144b84'
AND (
token = 'nBXPH7HukNdpDXMHapZTpa4iIDX2pbtfbHH46D+2oHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)