UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uc11Ju8V58RWlEVY+W2cIeU3r4KwdK909q08qY1EvT0='
WHERE
key_id = '46456786805839dd89445ea5f09cff3d85f5a36f523fd8972a1e34787e06c98a'
AND (
token = 'Uc11Ju8V58RWlEVY+W2cIeU3r4KwdK909q08qY1EvT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)