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