UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'psGjk5exY9QnTOvRqro7k6uzHTYn4llCnTJ7byJeaS8='
WHERE
key_id = 'a0b0895a411d308e847c6df0b3669b989a4dc5fc216e381baa99a35403366ec6'
AND (
token = 'psGjk5exY9QnTOvRqro7k6uzHTYn4llCnTJ7byJeaS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)