UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mIPTtO8yDUX4ODh1b+f1Y87Y39n/NR9nViA1tfc1U28='
WHERE
key_id = 'c79b08904564fc84183b7d016ccafcb644d25fe83c5050420073470404580a62'
AND (
token = 'mIPTtO8yDUX4ODh1b+f1Y87Y39n/NR9nViA1tfc1U28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)