UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcyWC3spZby/VGn4KY9zoselwdR8ntdUh2pKT2/bcHo='
WHERE
key_id = '239a246e31287b264ba4d457c3e7163e2050cec1d33977d756fdc84748bab59e'
AND (
token = 'zcyWC3spZby/VGn4KY9zoselwdR8ntdUh2pKT2/bcHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)