UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tK7Kw5Y89KrU2GeXOhL6vzy3MVZkKFfEC0jiyWDiJAE='
WHERE
key_id = '565cfea5617a2f0d4caa88b2887c9d99bbe7a03c4382262decc1cf72ac2ac4f0'
AND (
token = 'tK7Kw5Y89KrU2GeXOhL6vzy3MVZkKFfEC0jiyWDiJAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)