UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ILOTGkBxJeW25oFa2Ax5l3e1tf96ptdXCZgCnBoGn0='
WHERE
key_id = '580c6f13b686530787febba82c4cf2effc60195e1d0e7e32593448820c31ed4a'
AND (
token = '8ILOTGkBxJeW25oFa2Ax5l3e1tf96ptdXCZgCnBoGn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)