UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4X8NpQG24BXe8fuJCILCGfbHr+aLveW5R9I8XLSBSC0='
WHERE
key_id = 'b710a571c36ef326e86c0ad9dc75f4a1e44d841d26428f0a2d2d118d126e2653'
AND (
token = '4X8NpQG24BXe8fuJCILCGfbHr+aLveW5R9I8XLSBSC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)