UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2s/UXgATKrHVqieZMickT6oi50WDuAsyfdg47K/aLrg='
WHERE
key_id = '789eec1087c575d227a9a683ffc7a067da06cd77138c4563dcfb3673be209489'
AND (
token = '2s/UXgATKrHVqieZMickT6oi50WDuAsyfdg47K/aLrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)