UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UTCvCZZ4W6nqwPKx/tezRv5tpfbLaM6+0ok9x3X2eKQ='
WHERE
key_id = '1a71b57f2a53eefc1a4f6f6a41a5f678ed1f3fea9bc54ab8c7f5602844eb7095'
AND (
token = 'UTCvCZZ4W6nqwPKx/tezRv5tpfbLaM6+0ok9x3X2eKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)