UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cF2m3jRnB1VtczFugvPkB/ZE0d/JYNCfxD69mZ9V10='
WHERE
key_id = '7306a1aed215c679c0b0a812144253b37d05d0fc18f6e5dfbc8f5b04c139d1df'
AND (
token = '6cF2m3jRnB1VtczFugvPkB/ZE0d/JYNCfxD69mZ9V10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)