UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DITsfs+i8agVYLvuVCY1fNT9ykFndyDBWIZFs+MgmXE='
WHERE
key_id = '4a3c4715a9dcf31b07e4d3aac729d70f22499d852cbe6b52742019af74a07098'
AND (
token = 'DITsfs+i8agVYLvuVCY1fNT9ykFndyDBWIZFs+MgmXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)